<?php
require_once "../Common/values.php";
require_once "../Common/database.php";
require_once "theme.php";
echo '<body><h3>Log Search<p></h3>';
#echo '<p> User : '.$user ;
$_POST[logsearch]='%'.$_POST[logsearch];
$result = mysql_query("SELECT * FROM tblJobs where LogNumber LIKE '$_POST[logsearch]' AND Private!='checked'");

echo '<Table Border = 1 width=100%>';
echo '<tr><td>Log Number</td><td>Operator</td><td>Requestor</td><td>Subject</td></td><td>Proirty</td></td><td>Status</td></tr>';
while($row = mysql_fetch_array($result))
  {

  echo '<tr><td><a href=publicview.php?l='.$row['LogNumber'] .'>'.$row['LogNumber']. "</td><td>" . $row['Operator'].'</td>'.'<td>'.$row['Requestor'].'</td><td>'.$row[Subject].'</td>'.'<td>'.$row[Proirty].'</td>'.'<td>'.$row[Status].'</td>'.'</td></tr>';
  
  }
echo '</table>';
echo '<a href="../index.php">Back</a>';
mysql_close();
?>